Stored Procedures [dbo].[aspnet_UnRegisterSchemaVersion]
Properties
PropertyValue
ANSI Nulls OnNo
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Featurenvarchar(128)256
@CompatibleSchemaVersionnvarchar(128)256
Permissions
TypeActionOwning Principal
GrantExecuteaspnet_Membership_BasicAccess
GrantExecuteaspnet_Membership_ReportingAccess
GrantExecuteaspnet_Profile_BasicAccess
GrantExecuteaspnet_Profile_ReportingAccess
GrantExecuteaspnet_Personalization_BasicAccess
GrantExecuteaspnet_Personalization_ReportingAccess
SQL Script
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].aspnet_UnRegisterSchemaVersion
    @Feature                   nvarchar(128),
    @CompatibleSchemaVersion   nvarchar(128)
AS
BEGIN
    DELETE FROM dbo.aspnet_SchemaVersions
        WHERE   Feature = LOWER(@Feature) AND @CompatibleSchemaVersion = CompatibleSchemaVersion
END
GO
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_ReportingAccess]
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_ReportingAccess]
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_ReportingAccess]
GO
Uses